package com.proactive.webapp.dao;

import java.util.List;

import com.proactive.webapp.entity.Worksheet;

public interface WorksheetDAO {
	public int insert(Worksheet worksheet);
	public void update(Worksheet worksheet);
	public void updateStatus(Worksheet worksheet);
	public void updateViewCount(Worksheet worksheet);
	public Worksheet get(Worksheet worksheet);
	public Worksheet getByWriter(Worksheet worksheet);//
	public Worksheet getByLogin(Worksheet worksheet, String loginAccount);
	public List<Worksheet> getListByType(String type, int start, int size);
	public List<Worksheet> getListByCategory(String type, int categoryID, int start, int size);
	public List<Worksheet> getListByCategoryTop3(int categoryID, int currentWorksheetID);
	public int countTotal(int categoryID);
	public List<Worksheet> getListByMember(String account, int start, int size);
	public List<Worksheet> getListByWriter(String account, int start, int size);
	public int countTotalByMember(String account);
	public int countTotalByWriter(String account);
}
